if object_id('SemesterInsert') is not null
	drop proc SemesterInsert
	
go

create proc SemesterInsert
	@Description nvarchar(20),
	@Number int
as
begin
	insert into Semester ([Description], [Number]) values (@Description, @Number)
	select scope_identity()
end	

